If you take your exam in a manual transmission car, later on you are allowed to drive both kinds of vehicles.
If you decide to take the exam in an automatic transmission car, you will not be eligible to drive manual cars, unless you retake the exam in a manual transmission car.