A few hundred US citizens are left behind as final military transports depart just before midnight; General hopes they will still be able to leave Taliban-ruled country