I thought people may want to see a visual guide to this trophy so they know which car they are looking for and to see just how the car surfing actually works.
You may wish to try this out on some other cars to get the hang of it before going for the trophy.
What you have to do is jump on top of a car and you should get a prompt on the screen to press the triangle button to start car surfing. Once pressed it is basically a balancing game by using the left analogue stick to control your balance.
So once you have tried that out and got the hang of it you now need to find a comet car which as stated in the video is a 2 door car. So you can hang around an intersection and wait for one to pass and then jump on top and start car surfing and hopefully it will explode while doing so.
You don't have to do anything to initiate the explosion, it should just happen its self but not all of them seem to do this so it may take a few attempts before you get the trophy.
Here is the video for you to check it out, i hope this helps.
Good luck & happy gaming