With 50 needed off the last six overs with eight wickets in hand, India seemed to be on course to title triumph but lost