England will get smaller and smaller.
If I were Scottish I would at least want to vote on another referendum and I would likely vote to leave the UK in order to hopefully be a part of the EU.
Not that I'm a particular fan of the EU, but bigger market etc....
Almost all of Scotland's trade is with England. It's also been the poor man of the UK for generations, in the same way Quebec is for Canada. It wouldn't survive, economically, without the English paying so much of the bills. It would become a rump, poorer and more backward than it is now.