Either a 7/8th Gen Civic with manual transmission (never get a used prosmatec)
Or a 9th gen Altis/SE Saloon with auto transmission.
They are modern sedans with fairly planted suspension, and they are economical in the long run compared to a Suzuki hatchback, or even an old City. Fuel economy is not the only factor to look for in an economical car.