SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE mytable(
   date    DATE  NOT NULL 
  ,time    TIME NOT NULL
  ,zone    VARCHAR(4) NOT NULL
  ,device  VARCHAR(5) NOT NULL
  ,ORDERID INT 
);
INSERT INTO mytable(date,time,zone,device,ORDERID) VALUES ('2019-10-17','17:17:28','B','UN191',1);
INSERT INTO mytable(date,time,zone,device,ORDERID) VALUES ('2019-10-17','16:25:39','UN22','1',NULL);
INSERT INTO mytable(date,time,zone,device,ORDERID) VALUES ('2019-10-17','16:23:44','A','UN194',1);
INSERT INTO mytable(date,time,zone,device,ORDERID) VALUES ('2019-10-17','16:21:36','B','UN195',1);
INSERT INTO mytable(date,time,zone,device,ORDERID) VALUES ('2019-10-17','16:20:25','B','UN197',1);
INSERT INTO mytable(date,time,zone,device,ORDERID) VALUES ('2019-10-17','16:19:04','A','UN194',1);
INSERT INTO mytable(date,time,zone,device,ORDERID) VALUES ('2019-10-17','16:18:26','B','UN195',1);
INSERT INTO mytable(date,time,zone,device,ORDERID) VALUES ('2019-10-17','16:16:59','B','UN195',1);
INSERT INTO mytable(date,time,zone,device,ORDERID) VALUES ('2019-10-17','12:14:23','UN22','1',NULL);
INSERT INTO mytable(date,time,zone,device,ORDERID) VALUES ('2019-10-17','12:12:50','A','UN196',1);
INSERT INTO mytable(date,time,zone,device,ORDERID) VALUES ('2019-10-17','11:53:10','B','UN195',1);
INSERT INTO mytable(date,time,zone,device,ORDERID) VALUES ('2019-10-17','08:35:00','UN22','1',NULL);
INSERT INTO mytable(date,time,zone,device,ORDERID) VALUES ('2019-10-17','08:33:55','A','UN194',1);
INSERT INTO mytable(date,time,zone,device,ORDERID) VALUES ('2019-10-17','08:32:52','A','UN190',1);

14 rows affected

date_start	device_start	date_end	device_end	orderid	zone
17/10/2019 16:20:25	UN197	17/10/2019 16:21:36	UN195	1	B
17/10/2019 16:16:59	UN195	17/10/2019 16:18:26	UN195	1	B
17/10/2019 08:32:52	UN190	17/10/2019 08:33:55	UN194	1	A