Southern Brave finished fourth in The Hundred after Jason Roy hit 70 to clinch a four-run win over bottom side Welsh Fire in Southampton.