David Cameron has been caught revealing the Queen “purred down the line” after being informed Scotland had voted to remain in the United Kingdom.