Replace the all output of follow command that haven't the default value 'ASC' to use the default:
grep -R -P "orderBy\('[\w\.]+'\)" lib/
lib/Signaling/Messages.php: ->orderBy('id');
lib/Share/RoomShareProvider.php: $qb->orderBy('s.id');
lib/Share/RoomShareProvider.php: $qb->orderBy('id');
lib/Share/RoomShareProvider.php: ->orderBy('s.id')
lib/Share/RoomShareProvider.php: ->orderBy('id');
lib/Manager.php: ->orderBy('r.id');
If is ->orderBy('id') should be ->orderBy('id', 'ASC')
Originally posted by @nickvergessen in #9075 (comment)