Lord Mandelson would have been subject to a "thorough" and "intimate" vetting process before he was appointed UK ambassador to the US, a former head of MI6 has said.