Lord Mandelson has said it is a “great honour to serve the country” as the Prime Minister confirmed he had appointed him the next British ambassador to the US.