the orderBy is not working [adonis v6]

[amir-mohammad-HP]

i have a model and that has a order column inside, this model is working but when i try to index the model with an specific ordering like by "id" or by "order" column , it does not work as expected and the paginated response is the default ordering

also if i do not paginate and try to get first item the result would be the same and it return the first value by default order

// title: controller
export default class StepsController {
  async index(ctx: HttpContext) {
    const page = ctx.request.input('page', '1')
    const limit = ctx.request.input('limit', '10')

    const cg = await College.new(ctx)
    const { course_id: courseId } = cg.getContext().params
    const courseManager = await CourseManager.new(cg, courseId)
    const steps = courseManager.getCourseSteps.preload('icon')
    // CourseManager.getCourseSteps: HasManyQueryBuilderContract<typeof StepModel, StepModel>
    const lastStep = await courseManager.getCourseSteps.orderBy('order', 'desc').firstOrFail()
    const firstStep = await courseManager.getCourseSteps.orderBy('order', 'asc').firstOrFail()
    // firstStep and lastStep must not return same value but they do
   //  i guarantee i have more than 1 record in table
    const paginated = await steps.orderBy('id', 'asc').paginate(page, limit)
    return stepSerializedResponse(paginated)
  }
}

// title: model
export default class StepModel extends BaseModel {
  static table = 'steps'
  @column({ isPrimary: true })
  declare id: number

  @column()
  declare courseId: number

  @column()
  declare title: string

  @column({ serializeAs: null, columnName: 'icon' })
  declare iconId: number | null

  @column()
  declare order: number

  @column.dateTime({ autoCreate: true, serialize: timeToUnixInteger })
  declare createdAt: DateTime

  @column.dateTime({ autoCreate: true, autoUpdate: true, serialize: timeToUnixInteger })
  declare updatedAt: DateTime

  /**
   * Belong To
   */
  @belongsTo(() => SiteStorageModel, {
    foreignKey: 'iconId',
  })
  declare icon: BelongsTo<typeof SiteStorageModel>

  @belongsTo(() => CourseModel, {
    foreignKey: 'courseId',
  })
  declare course: BelongsTo<typeof CourseModel>
} 

// title: migration
async up() {
    this.schema.createTable(this.tableName, (table) => {
      table.charset(dbTableConfig.charset)
      table.collate(dbTableConfig.collation)
      table.bigIncrements('id').unsigned()
      table.bigInteger('course_id').unsigned().references('courses.id').notNullable()
      table.string('title').notNullable()
      table.bigInteger('icon').defaultTo(null).nullable()
      table.integer('order').notNullable()
      table.timestamp('created_at', { useTz: true })
      table.timestamp('updated_at', { useTz: true })
    })
  }