MsSQL Limit, Offset

SELECT Paginated.Id, Paginated.Name, Paginated.RowNum
FROM (
    SELECT Branch.Id, Branch.Name, ROW_NUMBER() OVER (ORDER BY Branch.Id) AS RowNum
    FROM Branch
) AS Paginated
WHERE Paginated.RowNum BETWEEN 6 AND 10