SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE StkTrans (
        TransID INT, 
        Part VARCHAR(25), 
        IN_Nr INT, 
        OUT_Nr INT, 
        OrderNr INT, 
        Type    VARCHAR(3)
    )

    INSERT INTO StkTrans
    (TransID, Part, IN_Nr, OUT_Nr, OrderNr, Type)
    VALUES
    (1, '123-1', 176573, NULL, 666000, 'IN' ),
    (2, '123-1', 176573, 171516, 111222, 'OUT' ),
    (3, '123-1', 179409, NULL, 111222, 'IN' ),
    (4, '123-1', 179409, 198306, 123332, 'OUT' ),
    (5, '123-1', 203944, NULL, 123332, 'IN' ),
    (6, '123-1', 203944, 224789, 125707, 'OUT' ),
    (7, '123-1', 232753, NULL, 125707, 'IN' ),
    (8, '123-1', 232753, 232233, 888777, 'OUT' )
8 rows affected

DECLARE @IN_Nr int = 232753;

WITH rCTE AS(
    SELECT V.*,
           1 AS Iteration
    FROM dbo.StkTrans STo
         JOIN dbo.StkTrans STi ON STo.IN_Nr = STi.IN_Nr      
         CROSS APPLY (VALUES(STo.TransID,STo.Part,STo.IN_Nr,STo.OUT_Nr,STo.OrderNr,STo.[Type]),
                            (STi.TransID,STi.Part,STi.IN_Nr,STi.OUT_Nr,STi.OrderNr,STi.[Type]))V(TransID,Part,IN_Nr,OUT_Nr,OrderNr,[Type])
    WHERE STo.IN_Nr = @IN_Nr
      AND STo.[Type] = 'OUT'
      AND STi.[Type] = 'In'
    UNION ALL
    SELECT V.*,
           r.Iteration + 1
    FROM dbo.StkTrans STo
         JOIN dbo.StkTrans STi ON STo.IN_Nr = STi.IN_Nr                     
         JOIN rCTE r ON STo.OrderNr = r.OrderNr
                    AND r.[Type] = 'In'
         CROSS APPLY (VALUES(STo.TransID,STo.Part,STo.IN_Nr,STo.OUT_Nr,STo.OrderNr,STo.[Type]),
                            (STi.TransID,STi.Part,STi.IN_Nr,STi.OUT_Nr,STi.OrderNr,STi.[Type]))V(TransID,Part,IN_Nr,OUT_Nr,OrderNr,[Type])
    WHERE STo.[Type] = 'Out'
      AND STi.[Type] = 'In')
SELECT TransID,
       Part,
       IN_Nr,
       OUT_Nr,
       OrderNr,
       [Type]
FROM rCTE
ORDER BY TransID DESC;


TransID
Part
IN_Nr
OUT_Nr
OrderNr
Type


8
123-1
232753
232233
888777
OUT

7
123-1
232753
null
125707
IN

6
123-1
203944
224789
125707
OUT

5
123-1
203944
null
123332
IN

4
123-1
179409
198306
123332
OUT

3
123-1
179409
null
111222
IN

2
123-1
176573
171516
111222
OUT

1
123-1
176573
null
666000
IN


DECLARE @IN_Nr int = 203944;

WITH rCTE AS(
    SELECT V.*,
           1 AS Iteration
    FROM dbo.StkTrans STo
         JOIN dbo.StkTrans STi ON STo.IN_Nr = STi.IN_Nr      
         CROSS APPLY (VALUES(STo.TransID,STo.Part,STo.IN_Nr,STo.OUT_Nr,STo.OrderNr,STo.[Type]),
                            (STi.TransID,STi.Part,STi.IN_Nr,STi.OUT_Nr,STi.OrderNr,STi.[Type]))V(TransID,Part,IN_Nr,OUT_Nr,OrderNr,[Type])
    WHERE STo.IN_Nr = @IN_Nr
      AND STo.[Type] = 'OUT'
      AND STi.[Type] = 'In'
    UNION ALL
    SELECT V.*,
           r.Iteration + 1
    FROM dbo.StkTrans STo
         JOIN dbo.StkTrans STi ON STo.IN_Nr = STi.IN_Nr                     
         JOIN rCTE r ON STo.OrderNr = r.OrderNr
                    AND r.[Type] = 'In'
         CROSS APPLY (VALUES(STo.TransID,STo.Part,STo.IN_Nr,STo.OUT_Nr,STo.OrderNr,STo.[Type]),
                            (STi.TransID,STi.Part,STi.IN_Nr,STi.OUT_Nr,STi.OrderNr,STi.[Type]))V(TransID,Part,IN_Nr,OUT_Nr,OrderNr,[Type])
    WHERE STo.[Type] = 'Out'
      AND STi.[Type] = 'In')
SELECT TransID,
       Part,
       IN_Nr,
       OUT_Nr,
       OrderNr,
       [Type]
FROM rCTE
ORDER BY TransID DESC;


TransID
Part
IN_Nr
OUT_Nr
OrderNr
Type


6
123-1
203944
224789
125707
OUT

5
123-1
203944
null
123332
IN

4
123-1
179409
198306
123332
OUT

3
123-1
179409
null
111222
IN

2
123-1
176573
171516
111222
OUT

1
123-1
176573
null
666000
IN


DROP TABLE dbo.StkTrans;
TransID	Part	IN_Nr	OUT_Nr	OrderNr	Type
8	123-1	232753	232233	888777	OUT
7	123-1	232753	null	125707	IN
6	123-1	203944	224789	125707	OUT
5	123-1	203944	null	123332	IN
4	123-1	179409	198306	123332	OUT
3	123-1	179409	null	111222	IN
2	123-1	176573	171516	111222	OUT
1	123-1	176573	null	666000	IN