Matthew Wade’s 81 proved bittersweet for Birmingham Phoenix as they beat London Spirit by one-wicket in a last-ball thriller at Lord’s but still bowed out of the 2022 Hundred.