Saints produced a stunning late comeback to beat Motherwell 2-1.