were you in favour of France or Germany having a vote on whether the UK should be allowed to break up the European Union?
Great point, love it!
No, it's a completely spurious point. The two referenda are not comparable as I pointed out on page 1.
The UK leaving the EU did not 'break up the European Union' (nor was it intended to), whereas Scotland separating from England & Wales would effectively break up the UK.
Scotland is the second largest member of the Union, the Scottish crown is equal in prestige and history to the English crown and the two have been intertwined for centuries (hence 'United Kingdom'). That's why Charles had to be crowned not just at Westminster but in Edinburgh too. (The royal coat of arms features both the English lion and the Scottish unicorn as 'supporters'.)
In contrast, while the UK was an important financial market for the EU, being the third largest contributor after Germany and France, it was just one of 28 nations, was not a founder member, and had only been part of that particular union for around 40 years - not even one generation.
Over the 300+ years of the union of the United Kingdom, multiple generations of Scots and English have become inter-related and have a shared culture, strong ties that cannot be said of the UK with the EU.
The modern obsession with Scottish independence is driven by extreme Scots Nats who have stoked it among more moderate Scots using dissatisfaction with Tory central government since Thatcher in the 1980s - but plenty of English and Welsh are fed up with the Tories too! Sadly, the extreme anti-English sentiments of many Scots Nats are inflaming English Nats too (who I also think should shut up) - both sides ignorant (or indifferent) to the damage to the whole nation they would cause if they get their own way.
The answer is not to take your ball and run away, but to unite to drive political change at national (UK) level.