Mandelson says it is ‘great honour’ to be named UK ambassador to US