Pakistan edged a thrilling game with neighbours Afghanistan to win by three wickets with two balls remaining at the ICC World Cup.