SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

10 rows affected

id	animalId	ownerId	iterator
1	123	62	1
2	123	182	1
3	240	27	1
4	2	30	1
5	73	35	1
6	123	62	2
7	108	162	1
8	2	30	2
9	2	30	3
10	73	35	2

id	animalId	ownerId	iterator
1	123	62	1
2	123	182	1
3	240	27	1
4	2	30	1
5	73	35	1
6	123	62	2
7	108	162	1
8	2	30	2
9	2	30	3
10	73	35	2

id	animalId	ownerId	iterator
1	123	62	1
2	123	182	1
3	240	27	1
4	2	30	1
5	73	35	1
6	123	62	2
7	108	162	1
8	2	30	2
9	2	30	3
10	73	35	2

id	animalId	ownerId	iterator
1	123	62	1
2	123	182	1
3	240	27	1
4	2	30	1
5	73	35	1
6	123	62	2
7	108	162	1
8	2	30	2
9	2	30	3
10	73	35	2