Auto increment using stored procedure

i want an auto increament using stored procedure haow can i do this process

i want a reference number in this procedure 

ALTER PROCEDURE [dbo].[Emp_Detail] 
	
(
           
            @Name varchar(max),
            @Emp_No varchar(50),
            @Job_Title varchar (max),
            @Nationality varchar(50),
            @Administration varchar(50),
            @Section  varchar(50),
            @Another_job varchar(50),
            @health_no  varchar(50),
            @Exp_Date Date,
            @National_ID numeric(18,0),
            @reference varchar(50)
            
)
AS
BEGIN
         
       
         
          INSERT INTO dbo.KSMCemp_data(Name,Emp_No,Job_Title,Nationality,Administration,Section,Another_job,health_no,Exp_Date,National_ID,serial_no,reference)
          values (@Name,@Emp_No,@Job_Title,@Nationality,@Administration,@Section,@Another_job,@health_no,@Exp_Date,@National_ID,@tempid,@reference)
         

 END