I'm not sure about the performance, but you can achieve order in view by using CTE
create view vLogin
as
with cte as
(
select *
, rowid=row_number() over(order by loginid asc)
from login.dbo.login
)
select *
from cte
This is allowed and works very well!! You might want to define some specific columns rather than *.