I see from Sturgeon's latest utterances, that she is relying on the EU vote to achieve independence.
The part where she talks about "denying the EU citizens in our country a vote" is key. Scotland, in it's fit of "fairness", allowed EU citiziens to vote in it's Independence referendum. Almost certainly ensuring a NO vote from all of them because the EU insisted that it would force Scotland out and they would have to apply again.
Now it's all reversed. If Scotland is able to have a referendum in the next 6 months, the EU are almost certainly going to reverse that decision which, as they will see it, will be one in the eye for the UK who have left.
In this scenario, the EU citizens in Scotland will almost certainly all vote Yes.
This works for me. Because the EU is now going to start coming under challenges more and more. The UK was a massive bulwark against the socialist ambitions of the more socialist states. Now the UK is gone those smaller countries it championed (none of whom EVER backed the UK when the chips were really down), are going to feel the pressure more and more. Sweden Democrats are going to soar in membership now that one country has finally left.
It would amuse me no end to see Scotland out of the UK and tied to a dying EU from which they had no recourse but to exit from 10 years later.
That would give me every single thing I aspire to.
However, the EU is a huge beast and it's death throes will be long and painful. It will fight, just as the USSR did. But unless it chooses to reform into a fully democratic federal government, I can't see it surviving now.
Britain led the world for hundreds of years. My take is that the British people have not lost that will to lead.