Lightning pip Swifts at the death in Super Netball thriller