SELECT TOP 4 * FROM
(
SELECT TOP 1 '1' AS myTipo, elenco_colonne FROM tabella WHERE Pacchetto='OLD' ORDER BY NEWID()
UNION
SELECT TOP 4 '2' AS myTipo, stesso_elenco_colonne FROM tabella WHERE Pacchetto='NEW' ORDER BY NEWID()
) AS TX
ORDER BY myTipo

provalo, l'ho scritto al buio