The BBC Radio 2 host was left red-faced after he was scolded by the ITV legend for his attempt at a Scottish accent – and he issued a public apology during his show