A huge collection of historic gold coins, recovered from the wall of a house in France after their owner passed away, has been sold for millions of euros at auction.