ListChildIssues and ListChildrenByParents ordered by
`position ASC, created_at DESC`. position is assigned by
NextTopPosition as MIN(position)-1 scoped to (workspace, status),
not relative to siblings, so a parent's children interleave
unpredictably across creation batches and statuses.
Order by `number` (a per-workspace monotonic counter) instead.
ASC keeps sub-issues in stable creation order (oldest first), so a
parent's plan reads top-to-bottom in the order tasks were added.
Adds ordering tests covering both queries with scrambled positions
and mixed statuses.
Closes#4232
MUL-3362
Co-authored-by: J <j@multica.ai>
Co-authored-by: multica-agent <github@multica.ai>
79c9158097