怎么在SQL Server 7.0里排序?

[cBeginner]

CREATE TABLE Supplier (
SupplierID smallint NOT NULL,
SupplierName char(25) NOT NULL,
CONSTRAINT PKSID PRIMARY KEY (SupplierID),
CONSTRAINT UKSN UNIQUE (SupplierName),
);
ORDERBY SupplierID;
INSERT INTO Supplier(SupplierID,SupplierName) VALUES
(1,'IBM');
INSERT INTO Supplier(SupplierID,SupplierName) VALUES
(2,'Microsoft');
INSERT INTO Supplier(SupplierID,SupplierName) VALUES
(3,'Oracle');
INSERT INTO Supplier(SupplierID,SupplierName) VALUES
(4,'Informix');

我想要输出结果是
1 IBM
2 Microsoft
3 Oracle
4 Informix

但是现在他输出
1 IBM
4 Informix
2 Microsoft
3 Oracle

我用Order By他说有错,不知道怎么排序?

[newly_ignorant]

插入时排序排序，没搞错吧

select SupplierID,SupplierName from Supplier order by SupplierID

[cBeginner]

INSERT INTO Supplier(SupplierID,SupplierName) VALUES
(1,'IBM');
INSERT INTO Supplier(SupplierID,SupplierName) VALUES
(2,'Microsoft');
INSERT INTO Supplier(SupplierID,SupplierName) VALUES
(3,'Oracle');
INSERT INTO Supplier(SupplierID,SupplierName) VALUES
(4,'Informix');
select *
from supplier
order by supplierid

运行之后在下面的窗口里排序我当然知道了,但是我要这个表打开的时候在表里也排好,现在就是当我打开表的时候不对(点右键,Open table, return all rows)