From Queen Elizabeth's astrologer to Norway's clairvoyant princess: Royals drawn to the supernatural