Fetch a checkpoint by its sequence number, or the latest checkpoint if no sequence number is provided.