[2.0] checkpoint: fix `current()`

Fix the query in `Checkpoint.current()` to correctly specify sorting
`seq DESC`. Before this change, the first checkpoint was returned as the
current one.

/to @raymondfeng please review
/cc @ritch