During a meeting with Taoiseach Micheál Martin, the US president said a united Ireland would be a "fantastic thing"