App: session list sorted by id rather than updated time

[neriousy]

Description

The session list is sorted by id rather than the update time which makes the session loading random

Plugins

none

OpenCode version

latest

Steps to reproduce

load session list -> load more

Screenshot and/or share link

No response

Operating System

No response

Terminal

No response

[github-actions]

This issue might be a duplicate of existing issues. Please check:

• GET /session: Add ORDER BY time_updated DESC to Session.list() for deterministic ordering and correct limit behavior #13569: Same root cause — Session.list() missing ORDER BY time_updated DESC, causing sessions to be returned in undefined/id order rather than by update time (closed issue that was previously assigned)