"or when Scotland and Ireland (Northern) vote to leave the UK"
Neither of those is going to happen.
Did the DUP tell you that? There'll be a border poll in the next two decades, we might have had one without Brexit, but it'll be an influence on the outcome. The more of a hash is made of the latter the more likely the former is to go south.