Change the order of the table from ASC to DESC .

It's exactly this: http://www.sqlfiddle.com/#!3/6c813/1

with bottom as(  
  select top 4 *
  from tbl
  order by n desc
)
select * 
from bottom
order by n

Data source:

|  N |
|----|
|  1 |
|  2 |
|  3 |
|  4 |
|  5 |
|  6 |
|  7 |
|  8 |
|  9 |
| 10 |

Output:

|  N |
|----|
|  7 |
|  8 |
|  9 |
| 10 |

Continue to use TOP, and reverse the order:

SELECT TOP 4 [news_title],
             [news_date_added],
             [news_short_description],
             [news_ID]
FROM   [Web_Xtr_News]
WHERE  ([news_type] = 2
         OR [news_type] = 3)
       AND [news_language] = @Language
ORDER  BY [news_ID] DESC

(It was rewritten to use parameters of course. Your original is vulnerable to SQL injection .)

You can reverse the ordering by using DESC instead of ASC at the end of your query.

A quick way to select batches from a list is to create a unique identifier like a (ROW ID) as (1, 2, 3, etc.) and create a nested query.

Select *
from
(select
   row_number() as id
   ,column1
   ,column2
from
  table1
)as D
where D.id (<>=! between)