President Donald Trump has touched a political nerve by saying a unified Ireland would be “fantastic.”