The Archbishop of Glasgow has revealed that he tried to comfort a woman who had seen her teenage daughter and both her parents “killed almost right in front of her” in the bin lorry tragedy.