How to get the results of the selection in the order in which the conditions are given?

Question

Yii

The select query has a condition

...
->andWhere(['in', 'product.id' , [2,21,3,64,38,35]])
->all();

What ->orderBy() should be so that the records are returned exactly in the order 2,21,3,64,38,35
If orderBy is not set, then it is sorted by id ASC.
--------
UPD: I was let down by the lack of Expression, this is how it works:

->orderBy([new \yii\db\Expression('FIELD (id, 2,21,3,64,38,35)')])

Answer 1

Depends on the database server.
For MySQL: Google ORDER BY FIELD()

Answer 2

Good evening.
Is it necessary to sort by id? Maybe sorting on another field will suit you?