A dramatic final over saw the home side chase down the target with a six off the last ball, sealing the series in front of a sold-out stadium.