I made this Checkpoint Example CAPX a few days ago.
When you move the player over the red boxes in preview, the last one you reached is always green. When the game is restarted, the player will spawn next to the last active checkpoint. So it should be exactly what you're looking for.
I you have any questions about it feel free to ask!
I hope I could help!