Simon Cowell shocked traders after he appeared at a card trading show and spent thousands of pounds on a rare Pokémon card.