var some= db.Table.Where(x => x.GroupId == 1).OrderBy(x => x.Id)
                                          .Skip(10).Take(10)
                                          .Select(x => new
                                                  {
                                                      Id = x.Id,
                                                      Name = x.Name,
                                                      SortOrder = x.SortOrder
                                                  }).ToList();

SELECT TOP (10) 
[Project1].[Id] AS [Id], 
[Project1].[Name] AS [Name], 
[Project1].[SortOrder] AS [SortOrder]
FROM ( SELECT [Project1].[Id] AS [Id], [Project1].[Name] AS [Name], [Project1].[SortOrder] AS [SortOrder], row_number() OVER (ORDER BY [Project1].[Id] ASC) AS [row_number]
        FROM ( SELECT 
                [Extent1].[Id] AS [Id], 
                [Extent1].[Name] AS [Name], 
                [Extent1].[SortOrder] AS [SortOrder]
                FROM [dbo].[Table] AS [Extent1]
                WHERE [Extent1].[GroupId ] = @p__linq__0
        )  AS [Project1]
)  AS [Project1]
WHERE [Project1].[row_number] > 10
ORDER BY [Project1].[Id] ASC