SQL Server 2017

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

create table your_table (
 id int identity(101,1) primary key, 
 col1 int
);
with rcte as (
 select 1 as n
 union all
 select n+1 from rcte where n < 100
)
insert into your_table (col1)
select * from rcte;
100 rows affected

declare @seed int = 42;
select top 5 *
from your_table
order by rand(HashBytes('MD5', concat(col1, @seed)));


id
col1


164
64

200
100

188
88

150
50

106
6


declare @seed int = 42;
select top 5 *
from your_table
order by rand(HashBytes('MD5', concat(col1, @seed)));


id
col1


164
64

200
100

188
88

150
50

106
6


declare @seed int = 43;

select top 5 *
from your_table
order by rand(HashBytes('MD5', concat(col1, @seed)));


id
col1


111
11

112
12

117
17

180
80

150
50