India beat Pakistan by five wickets in a tense final to retain the Asia Cup at the Dubai International Cricket Stadium.