Mysql查询结果顺序按 in() 中ID 的顺序排列

<select id="listTagByIds" resultType="la.kaike.ziyue.dmhub.tag.service.dto.TagInfoDTO">
         SELECT
          *
        FROM
          tag_info
        WHERE
          id in
          <foreach collection="tagIdList" open="(" item="item" separator="," close=")">
              #{item}
          </foreach>
          order by field
        <foreach collection="tagIdList" open="(id," item="item" separator="," close=")">
            #{item}
        </foreach>
    </select>

sql 最终被拼写为：
SELECT * FROM tag_info WHERE id in ( ? , ? , ? , ? , ? , ? , ? , ? ) order by field (id, ? , ? , ? , ? , ? , ? , ? , ? )