Better practice is to maintain a sequence column in the table.

Anyways following is the query ....

Declare @tblTemp table ( ID int identity(1,1)

, houseno varchar(25)

)

Insert into @tblTemp

Select '3-13-1' union all

Select '3-13-3/a' union all

Select '3-13-3/b' union all

Select '3-13-2/a' union all

Select '3-13-4' union all

Select '3-13-6' union all

Select '3-13-5/a' union all

Select '3-13-4/c'

Select * from @tblTemp

Order by REPLACE(houseno,'-','')

Hope it helps