如何在hibernate子查询中同时使用行号和排序依据？

CriteriaBuilder criteriaBuilder = entityManager.getCriteriaBuilder();
CriteriaQuery<Entity> criteriaQuery = criteriaBuilder.createQuery(Entity.class);
Root<Entity> root = criteriaQuery.from(Entity.class);

// 创建子查询
Subquery<Long> subquery = criteriaQuery.subquery(Long.class);
Root<Entity> subRoot = subquery.from(Entity.class);
subquery.select(criteriaBuilder.count(subRoot));

// 添加子查询的条件
Predicate subPredicate = criteriaBuilder.equal(subRoot.get("someProperty"), someValue);
subquery.where(subPredicate);

// 添加主查询的条件
Predicate predicate = criteriaBuilder.and(
    criteriaBuilder.equal(root.get("someProperty"), someValue),
    criteriaBuilder.exists(subquery)
);
criteriaQuery.where(predicate);

// 添加排序依据
Order order = criteriaBuilder.asc(root.get("someProperty"));
criteriaQuery.orderBy(order);

// 执行查询
TypedQuery<Entity> query = entityManager.createQuery(criteriaQuery);
List<Entity> results = query.getResultList();