The VW emissions scandal could be the start of the end of diesel as a viable fuel source for mass-market passenger vehicles.