When the Democratic Unionist party decided to support Brexit, many warned that the decision could have profound consequences for Northern Ireland’s position within the UK.