I'm not ENTIRELY sure that even in the outside chance of another referendum in the foreseeable future that your wishes would necessarily come true.
First, they would need a victory, secondly and more importantly is the EU taking up the offer of Scotland's generous offer of membership.