Unless the Orkney islands vote to stay, which they did by 70% last time. They have a history separate to Scotland and this would keep most of North Sea oil too.

Yeah, but there’s no provision to break up Scotland & let Orkney & Shetland (not just Orkney!) stay in the UK if Scotland secedes, any more than Bristol, Oxford, Brighton or Reading (all with far more people than Orkney & Shetland) can stay in the EU if the UK leaves, despite voting Remain.