The Champagne region wasn’t always known for sparkling wine. Sophie Thorpe uncovers how the region discovered the bubbles that made its name