I made an analysis on this topic and found the results in the simplest answer.
Go for a Diesel car - If you have more than 1500~ 2000 Kms per month of ride.
Go for a Petrol car - If you have less than 1500 Kms run.
Please refer the attached.