Welsh Fire are eliminated from The Hundred as they suffer a six-run defeat by London Spirit in their final group phase match in Cardiff.