A former aide of the late monarch has revealed Queen Elizabeth used to terrify passengers with her high-speed driving.