MariaDB 10.4

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

CREATE TABLE participant_teams (
  team_id int(11) NOT NULL,
  team_name text NOT NULL,
  created_by int(11) NOT NULL,
  team_profile text NOT NULL,
  team_member text NOT NULL,
  baller_event_id_fk int(11) NOT NULL,
  pay_status text NOT NULL COMMENT 'pending, paid, cancelled',
  team_score double NOT NULL,
  registered_on timestamp NOT NULL DEFAULT current_timestamp(),
  updated_on timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO participant_teams (team_id, team_name, created_by, team_profile, team_member, baller_event_id_fk, pay_status, team_score, registered_on, updated_on) VALUES
(1, 'Summer Havoc', 2, 'uploads/54988c5c833638d4c19546fbc8de1a35.jpg', '5,2', 1, 'paid', 25, '2022-01-04 13:12:39', '2022-01-04 13:12:39'),
(2, 'Jammers Classic', 4, 'uploads/54988c5c833638d4c19546fbc8de1a35.jpg', '4,3', 1, 'paid', 6.25, '2022-01-04 13:13:17', '2022-01-04 13:13:17'),
(3, 'Brickslayers', 7, 'uploads/54988c5c833638d4c19546fbc8de1a35.jpg', '7,10', 1, 'paid', 12.5, '2022-01-05 07:18:08', '2022-01-05 07:18:08'),
(4, 'Basket Bombers', 9, 'uploads/54988c5c833638d4c19546fbc8de1a35.jpg', '9,8', 1, 'paid', 0, '2022-01-05 07:18:45', '2022-01-05 07:18:45');

SELECT team_id,team_name,team_score
FROM (
  SELECT team_id,team_name,team_score,
  abs(ROW_NUMBER() OVER(ORDER BY team_score)  - 
  ROW_NUMBER() OVER(ORDER BY team_score DESC)) rn  
FROM participant_teams
) t1
ORDER BY rn desc

team_id	team_name	team_score
1	Summer Havoc	25
4	Basket Bombers	0
3	Brickslayers	12.5
2	Jammers Classic	6.25