SunRisers Leeds booked a meeting with Trent Rockets in The Hundred women's final after a tense five-wicket win over Southern Brave in the eliminator at The Kia Oval.