ordering by id should take less effort than ordering by created_at and is low risk since we have no intention of backfilling chat events.

following this pr I will create a migration that adds indexes for the chat_history query that includes the id

Links

• Jira: https://codedotorg.atlassian.net/browse/TEACHING-48

Testing story

Deployment strategy

Follow-up work

Privacy

Security

Caching

PR Creation Checklist:

• Tests provide adequate coverage
• Privacy impacts have been documented
• Security impacts have been documented
• Code is well-commented
• New features are translatable or updates will not break translations
• Relevant documentation has been added or updated
• User impact is well-understood and desirable
• Follow-up work items (including potential tech debt) are tracked and linked