Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE mytable(
   id           INTEGER  NOT NULL PRIMARY KEY 
  ,collection_id INTEGER  NOT NULL
  ,info_text     VARCHAR(12) NOT NULL
);
begin
INSERT INTO mytable VALUES (20200227112631476162094432822589,20200227112630931296846572143651,'Step 0');
INSERT INTO mytable VALUES (20200227112631512664092998338570,20200227112630931296846572143651,'Step 1');
INSERT INTO mytable VALUES (20200227112631652576662844108316,20200227112630931296846572143651,'Successful');
end;
/
1 rows affected

	select
		collection_id,
		to_timestamp(substr(collection_id, 1, 17), 'yyyymmddhh24missff') start_timestamp,
		to_timestamp(substr(id,            1, 17), 'yyyymmddhh24missff') end_timestamp,
		info_text last_status
	from (
		select 
			t.*,
			row_number() over(partition by collection_id order by id desc) rn
		from mytable t
	) t
	where rn = 1


COLLECTION_ID
START_TIMESTAMP
END_TIMESTAMP
LAST_STATUS


20200227112630931296846572143651
27-FEB-20 11.26.30.931000000
27-FEB-20 11.26.31.652000000
Successful