Most people, when they encounter royalty, are on their best behaviour. But the stress of such a big occasion triggered youth worker John Davidson’s condition, leading to an awkward moment