US President Donald Trump made international headlines when he said in Dublin that he would "love" to see Irish unity.