Prince Andrew in April. Today, Andrew's reputation is in tatters but even as a young child, the late Queen's favourite son was known as a troublesome member of the family