What we all need now is another EU/UK land border to find solutions for
If I were a resident of Scotland I would be wondering how much sense it makes divorcing from my nearest neighbour, the UK, whilst seeking re-admittance to a rather distant EU.
I doubt another vote on the matter will happen as long as BJ is still in office. It will come when SNP support is necessary to prop up a new UK Labour Government, which will also mean that Labour sign away long term prospects of power in what remains of the UK when Scotland is gone. If the vote goes wrong for them. We would then need a reconfiguring of the UK parties to ensure we continue to have a choice of government.
The chances are that if there is another referendum in the next few years, it will be with a Labour PM in Downing Street. Without a bogeyman figure like BJ there it may be harder to rouse Scottish voters to opt for yet more upheaval after what has been a turbulent decade or more. If I had to put money on it, I'd say they will stay.