Trent Rockets are crowned men's Hundred champions after beating Manchester Originals by two wickets in a thrilling final at Lord's.