Diesel prices recorded their biggest monthly fall since records began in 2000 during June, according to RAC Fuel Watch data.