Hoppers beat Sheffield Tigers in dramatic fashion with a last-minute try to take five points back home with them.