I have added this function to the apps script and named it total.gs

function recordB49Values() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('SchoolWiseList');
  const resultSheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName('Total1');

  const originalF2Value = sheet.getRange('F2').getValue();

  for (let i = 1; i <= 11; i++) {
    sheet.getRange('F2').setValue(i);
    SpreadsheetApp.flush();
    
    const B49Value = sheet.getRange('B49').getValue();
    
    resultSheet.getRange(i + 1, 1).setValue(i);
    resultSheet.getRange(i + 1, 2).setValue(B49Value);
  }

  sheet.getRange('F2').setValue(originalF2Value);
  SpreadsheetApp.flush();
}

Then I have added a sheet named Total1. In the Total1 sheet,I set up the headers:

Cell A1: School Number

Cell B1: Total Competitors

Then I run the function recordB49Values from the apps script.