Northern confirm semi-final spot with thrilling last over win