Scotland could never leave. Britain doesn't want to loose Scotland and Europe doesn't want to split up all the British kingdoms and have them join one by one.

Northern Ireland has a chance to leave the shithole that is brexit by joining Ireland, but does Ireland want that? You're gonna spark a fire if you do that. The politics and rebellions of the 80's are only dormant, the sentiment is far from gone.