One reason why I doubt that Scotland will truly leave the UK and join the EU is because then the border between Scotland and England would have to be controlled.
And I just can’t see them doing that.
Hadrian’s wall isn’t what it used to be.