The US President said he is supportive of the idea of a united Ireland and said that "it may as well happen now"