I would suggest you to go for Civic Reborn 2006 vti manual and you would love the ride quality and comfort, my elder bro gets 13-13.5km/l in intercity with thorough proper maintainence, try to get a vehicle with 3S maintained history and you would love it.
Dont get worried about engine capacity it just makes a little difference, for instance I am getting 13.5 in intercity from my Honda Civic EXi manual 2003, 175k driven with thoruoghly Honda 3S maintained and I easily get 8-8.5km/l from my 1989 HJ60, 3980 cc, inline six diesel, non turbo, 5-spd manual and 10km/l on highway at a speed of 100km/h abnd its too good considering its weight, tire size and aerodynamics of a brick.
Fuel consumption matter wrt engine capacity but not directly proportional.