An Irish border poll is “off the table”, Prime Minister Andy Burnham has said.