US stun Pakistan in Super Over to seal famous win