Holders Brave beaten as Knight inspires SpiritEngland's Heather Knight led London Spirit to victory in The Hundred women's competition against Southern Brave.