You can write a script that checks when the car engine is starting, then play your ignition audio source.
Use the data bus for retrieving the state of the car. The value EngineStarting in the Vehicle channel is non-zero when the engine is starting as per the user input (ignition key).
Including ignition audio is planned for an upcoming update of the VPAudio component.