Lord Peter Mandelson was appointed as the UK’s ambassador to the US despite failing the security vetting process.