Dear Fahad,
Alhamdulillah - i am using 2007 honda city - manual. I was 2nd owner (for last 3 years) and its first owner was a Dr. very well maintained car and only on petrol driven. previously i owned 2006 Manual city + CNG but it was very badly managed car by previous owner, engine check light was on always - i ended up this vehicle on a loss of 1lac plus.
Main thing is you need to get a good, maintained car else it was hell. 850, now its difficult to get.
Good luck in finding a car.