Getting a minimum total number of rows either side of a specific row, Sql Server

Language: Layout:

create table dbo.PlayerScores (Id int, Name nvarchar(64), Score int)
  insert into dbo.PlayerScores (Id, Name, Score) values
   (1,'Bob',17) ,(2,'Carl',24) ,(3,'Ann',31) ,(4,'Joan',11)
  ,(5,'Lou',17) ,(6,'Dan',25) ,(7,'Erin',33) ,(8,'Fred',29);
go
/* ordered resultset */

create procedure dbo.PlayerScores_getMiddle5_byId (@PlayerId int) as 
begin;
with cte as (
  select
      Score_Order = row_number() over (order by Score desc)
    , Score_Rank  = rank() over (order by Score desc)
    , Id
    , Name
    , Score
    from dbo.PlayerScores
    )
, TargetOrder as (
    select 
        Score_Order 
    from cte 
    where Id = @PlayerId
    )

select c.Score_Rank, c.Name, c.Score
  from (select top 5 i.* 
        from cte i 
          cross apply (select Score_Order from TargetOrder) as  x
          order by abs(i.Score_Order-x.Score_Order)) as  c
  order by Score_Rank;
end
go
exec dbo.PlayerScores_getMiddle5_byId 7; -- Erin
exec dbo.PlayerScores_getMiddle5_byId 6; --Dan
exec dbo.PlayerScores_getMiddle5_byId 5; --Lou

go
/* unordered result set */
/* 
create procedure dbo.PlayerScores_getMiddle5_byId (@PlayerId int) as 
begin;
with cte as (
  select
      Score_Order = row_number() over (order by Score desc)
    , Score_Rank  = rank() over (order by Score desc)
    , Id
    , Name
    , Score
    from dbo.PlayerScores
    )

select top 5 c.Score_Rank, c.Name, c.Score
  from cte as c
    cross apply (select 
        Score_Order 
    from cte 
    where Id = @PlayerId) as x
    order by abs(c.Score_Order-x.Score_Order) 
  
end
--go
exec dbo.PlayerScores_getMiddle5_byId 7; -- Erin
exec dbo.PlayerScores_getMiddle5_byId 6; --Dan
exec dbo.PlayerScores_getMiddle5_byId 5; --Lou
--*/

View schema
Execution time: 0,02 sec, rows selected: 15, rows affected: 8, absolute service time: 0,2 sec