SQL return the insert row id

alter procedure [dbo].[usp_SomeName] (
@value varchar(100)
) as
declare @id int
create table #out(id int, value varchar(100))
INSERT INTO test2
(value)
output inserted.* into #out
VALUES
(@value)
return (select top 1 id from #out)